﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'P_DeleteUserGroupsOfUser')
	BEGIN
		DROP  Procedure  [esf_sso].P_DeleteUserGroupsOfUser
	END

GO

CREATE Procedure [esf_sso].P_DeleteUserGroupsOfUser
	@pUserPersonID	INT
AS

	DELETE FROM [esf_sso].User_UserGroup 
	WHERE UserPersonID = @pUserPersonID

GO